Restore

Navicat provides you a useful tool for restoring your backup while hardware failure occurs.

To open a restore windows (see Restore Backup for details).

Note: You must have Create, Drop and Insert Privileges (MySQL or PostgreSQL) to run the restore.

Hint: Restore function will firstly drop the selected objects of the database, then recreate the new objects according to your backup. Finally, inserting the data.

To restore a backup with default settings from the command line


See also:
Backup
Execute SQL File